ROUNDSIG

Rounds a number to a specified number of significant figures.

Syntax

ROUNDSIG(number, num_digits)

number - is the number you want to round.

num_digits - specifies the number of significant figures to which you want to round number.

Remark

• Arguments that are error values or text that cannot be translated into numbers cause errors. See the third example below.
• If num_digits is greater than 0 (zero), then numbers are rounded to the specified number of decimal places.
• If num_digits is 0, then numbers are rounded to the nearest integer.
• If num_digits is less than 0, then numbers are rounded to the left of the decimal point.

Examples

ROUNDSIG(149.149, 1) equals 100

ROUNDSIG(149.149, 2) equals 150

ROUNDSIG(149.149, 3) equals 149

ROUNDSIG(149.149, 4) equals 149.1

ROUNDSIG(149.149, 5) equals 149.15

ROUNDSIG(149.149, 6) equals 149.149

 

[ ©2000-2001, Edwin H. B. Tam, All rights reserved ]